from django.db import models

# Create your models here.
class Business(models.Model):
    id = models.AutoField(primary_key=True)
    mobile = models.CharField(max_length=64, null=False)
    department = models.CharField(max_length=64,null=False)
    the_name = models.CharField(max_length=64,null=False)
    password = models.CharField(max_length=64,null=False)

class Sheet1(models.Model):
    时间 = models.DateField(auto_now=False)
    商品编码 = models.CharField(max_length=255, blank=True, null=True)
    款式编码 = models.CharField(max_length=255, blank=True, null=True)
    颜色 = models.CharField(max_length=255, blank=True, null=True)
    规格 = models.CharField(max_length=255, blank=True, null=True)
    商品名称 = models.CharField(max_length=255, blank=True, null=True)
    产品分类 = models.CharField(max_length=255, blank=True, null=True)
    实发数量 = models.CharField(max_length=255, blank=True, null=True)
    销售数量 = models.CharField(max_length=255, blank=True, null=True)
    虚拟分类 = models.CharField(max_length=255, blank=True, null=True)
    实退数量 = models.CharField(max_length=255, blank=True, null=True)

class NoallStype(models.Model):
    款式编码 = models.CharField(max_length=255, blank=True, null=True)
    库存 = models.CharField(max_length=255, blank=True, null=True)
    分类 = models.CharField(max_length=255, blank=True, null=True)
    生产周期 = models.CharField(max_length=255, blank=True, null=True)

class AllStype(models.Model):
    款式编码 = models.CharField(max_length=255, blank=True, null=True)
    库存 = models.CharField(max_length=255, blank=True, null=True)
    分类 = models.CharField(max_length=255, blank=True, null=True)
    生产周期 = models.CharField(max_length=255, blank=True, null=True)

